create database AutoIn
go
use AutoIn

CREATE TABLE Author 
(
   Id  int  NOT NULL PRIMARY KEY identity,
   FirstName  nvarchar(45) NOT NULL,
   LastName  nvarchar(45) NOT NULL,
   UpdatedTime  datetime NOT NULL
 )

create unique index uniq_idx_firstname
on Author(FirstName)

create index idx_lastname
on Author(LastName)
with FILLFACTOR = 30
